Tables [dbo].[AppealProduct]
SQLServer > iMIS1521GA > Tables > dbo.AppealProduct
Properties
PropertyValue
Created10:31:13 AM Tuesday, March 02, 2010
Last Modified11:40:00 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_AppealProduct: AppealProductKeyAppealProductKeyuniqueidentifier16
No
Foreign Keys FK_AppealProduct_AppealMain: [dbo].[AppealMain].AppealKeyAppealKeyuniqueidentifier16
No
ProductCodenvarchar(31)62
No
MarkedForDeleteOndatetime8
Yes
ProductKeyuniqueidentifier16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_AppealProduct: AppealProductKeyPK_AppealProductAppealProductKey
Yes
Foreign Keys Foreign Keys
NameDeleteColumns
FK_AppealProduct_AppealMainCascadeAppealKey->[dbo].[AppealMain].[AppealKey]
SQL Script
CREATE TABLE [dbo].[AppealProduct]
(
[AppealProductKey] [uniqueidentifier] NOT NULL,
[AppealKey] [uniqueidentifier] NOT NULL,
[ProductCode] [nvarchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MarkedForDeleteOn] [datetime] NULL,
[ProductKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AppealProduct] ADD CONSTRAINT [PK_AppealProduct] PRIMARY KEY CLUSTERED ([AppealProductKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AppealProduct] ADD CONSTRAINT [FK_AppealProduct_AppealMain] FOREIGN KEY ([AppealKey]) REFERENCES [dbo].[AppealMain] ([AppealKey]) ON DELETE CASCADE
GO
Uses
Used By
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved